package com.example.springbootsfzy.mapper;

import com.example.springbootsfzy.domain.PrivateMessages;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageInfo;

import java.util.List;

/**
* @author 30658
* @description 针对表【private_messages】的数据库操作Mapper
* @createDate 2025-01-02 15:11:37
* @Entity com.example.springbootsfzy.domain.PrivateMessages
*/
public interface PrivateMessagesMapper {

    //根据memberId查看全部
    List<PrivateMessages> getPrivateMessages(int id);

    //通过 id 删除
    int deleteByPrimaryKey(int id);

    //通过consultant_id查
    List<PrivateMessages> selectByconsultantid(int id);

    //添加
    int insert(PrivateMessages record);

    int insertSelective(PrivateMessages record);

    PrivateMessages selectByPrimaryKey(int id);

    int updateByPrimaryKeySelective(PrivateMessages record);

    int updateByPrimaryKey(PrivateMessages record);

    Page<PrivateMessages> getPrivateMessagesByConsultantId(int consultantId);

}
